SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].gspRating_UPDATE
(
@ratingId int = null,
@productId int = null,
@commentId int = null,
@ratingValue int = null,
@createdDate datetime = null,
@lastModifiedDate datetime = null,
@isDeleted bit = null
)
AS

UPDATE
  [dbo].[Rating]
SET
  [ProductId] = @productId,
  [CommentId] = @commentId,
  [RatingValue] = @ratingValue,
  [CreatedDate] = @createdDate,
  [LastModifiedDate] = @lastModifiedDate,
  [IsDeleted] = @isDeleted
WHERE
  [RatingId] = @ratingId


GO
